package com.itrip.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itrip.entity.ItripAreaDic;
import org.apache.ibatis.annotations.Select;
import org.springframework.web.bind.annotation.PathVariable;

import java.util.List;
import java.util.Map;

public interface ItripAreaDicMapper extends BaseMapper<ItripAreaDic>{
    //查询酒店视频信息
    @Select(" select a.id as id,(select d.name FROM itrip_area_dic d WHERE d.isActivated=1 AND d.id = a.areaId) AS name from itrip_hotel_trading_area a where a.id=#{id}")
    public List<ItripAreaDic> getItripOrderLinkUserIdsByOrder(@PathVariable Long id);
}
